Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER No null 1 null NO NO NO
OBJ VARCHAR2(20) No null 2 null NO NO NO
ID VARCHAR2(100) No null 3 null NO NO NO
TITLE VARCHAR2(100) No null 4 null NO NO NO
COMPLAINT_TYPE VARCHAR2(4000) Yes null 5 null NO NO NO
COMPLAINT_DATE DATE Yes null 6 null NO NO NO
RECEIPT_DATE DATE Yes null 7 null NO NO NO
INITIAL_ASSESSMENT VARCHAR2(4000) Yes null 8 null NO NO NO
INITIAL_ALLEGATION VARCHAR2(4000) Yes null 9 null NO NO NO
INCIDENT_LOCATION VARCHAR2(4000) Yes null 10 null NO NO NO
SUBJECTS VARCHAR2(4000) Yes null 11 null NO NO NO
STATUS VARCHAR2(100) Yes null 12 null NO NO NO
DISPOSITION VARCHAR2(4000) Yes null 13 null NO NO NO
DISPOSITION_DATE DATE Yes null 14 null NO NO NO
OPEN_DATE DATE Yes null 15 null NO NO NO
OPEN_DATE_FY NUMBER Yes null 16 null NO NO NO
CLOSED_DATE DATE Yes null 17 null NO NO NO
CLOSED_DATE_FY NUMBER Yes null 18 null NO NO NO
DAYS_OPEN NUMBER(38) Yes null 19 null NO NO NO
LEAD_PERSONNEL VARCHAR2(400) Yes null 20 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(4000) Yes null 21 null NO NO NO
NEXT_DUE_DATE DATE Yes null 22 null NO NO NO
FINAL_DUE_DATE DATE Yes null 23 null NO NO NO
FINAL_DUE_DATE_FY NUMBER Yes null 24 null NO NO NO
FINAL_DUE_DATE_MET VARCHAR2(3) Yes null 25 null NO NO NO
CREATED_DATE DATE Yes null 26 null NO NO NO
CREATED_ON_FY NUMBER Yes null 27 null NO NO NO
LAST_MODIFIED_DATE DATE Yes null 28 null NO NO NO
COMPLAINT_SOURCE VARCHAR2(4000) Yes null 29 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_INTAKE_ASSOC_FILES VIEW QART V_SIIC_INTAKE VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_SIIC_INTAKE VIEW QART MV_ACM_OBJ TABLE
QART V_SIIC_INTAKE VIEW QART MV_ACM_REFERENCE TABLE
QART V_SIIC_INTAKE VIEW QART V_CURR_OBJ_STAKEHOLDERS VIEW
QART V_SIIC_INTAKE VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_SIIC_INTAKE VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_SIIC_INTAKE VIEW QART MV_F_INTAKE TABLE
NAME VALUE
CREATED 24-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_SIIC_INTAKE
TEXT_LENGTH 2992
TEXT SELECT DISTINCT           I.SID,           I.OBJ,           I.ID,           I.TITLE,           I.COMPLAINT_TYPE,           I.COMPLAINT_DATE,           I.RECEIPT_DATE,           R2.DISPLAY INITIAL_ASSESSMENT,           R3.DISPLAY INITIAL_ALLEGATION,           R5.DISPLAY INCIDENT_LOCATION,           SUB.SUBJECTS,           STAT1.STATUS,           R4.DISPLAY,   I.DISPOSITION_DATE,           TRUNC (STAT2.STARTED_ON) OPEN_DATE,           STAT2.STARTED_ON_FY OPEN_DATE_FY,           TRUNC (STAT3.STARTED_ON) CLOSED_DATE,           STAT3.STARTED_ON_FY CLOSED_DATE_FY,           (TRUNC (NVL (STAT3.STARTED_ON, SYSDATE)) - TRUNC (STAT2.STARTED_ON))              DAYS_OPEN,           SH1.SH_DISPLAY LEAD_PERSONNEL,           SH2.SH_DISPLAY SUPPORT_PERSONNEL,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN --STAT3.CODE = 'CLOSED' AND                  TRUNC (STAT3.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE)              THEN                 'Yes'              ELSE                 'No'           END              FINAL_DUE_DATE_MET,           O.CREATED_ON CREATED_DATE,           O.CREATED_ON_FY CREATED_ON_FY,           O.LAST_MODIFIED_ON LAST_MODIFIED_DATE,   I.COMPLAINT_SOURCE      FROM MV_F_INTAKE I           INNER JOIN MV_ACM_OBJ O              ON I.OBJ = O.SID           LEFT JOIN MV_ACM_REFERENCE R2              ON I.INITIAL_ASSESSMENT = R2.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R3              ON I.INITIAL_ALLEGATION = R3.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R4              ON I.DISPOSITION = R4.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R5              ON I.INCIDENT_LOCATION = R5.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SUBJECTS                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN V_OBJ_STATUS_HISTORY STAT2              ON I.OBJ = STAT2.OBJ AND STAT2.CODE LIKE 'OPEN'           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'           LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH1              ON I.OBJ = SH1.OBJ AND SH1.CODE = 'LEAD'           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (SH_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY SH_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SH_DISPLAY                        FROM V_CURR_OBJ_STAKEHOLDERS                       WHERE CODE = 'SUPPORT') SH2              ON I.OBJ = SH2.OBJ
TEXT_VC SELECT DISTINCT           I.SID,           I.OBJ,           I.ID,           I.TITLE,           I.COMPLAINT_TYPE,           I.COMPLAINT_DATE,           I.RECEIPT_DATE,           R2.DISPLAY INITIAL_ASSESSMENT,           R3.DISPLAY INITIAL_ALLEGATION,           R5.DISPLAY INCIDENT_LOCATION,           SUB.SUBJECTS,           STAT1.STATUS,           R4.DISPLAY,   I.DISPOSITION_DATE,           TRUNC (STAT2.STARTED_ON) OPEN_DATE,           STAT2.STARTED_ON_FY OPEN_DATE_FY,           TRUNC (STAT3.STARTED_ON) CLOSED_DATE,           STAT3.STARTED_ON_FY CLOSED_DATE_FY,           (TRUNC (NVL (STAT3.STARTED_ON, SYSDATE)) - TRUNC (STAT2.STARTED_ON))              DAYS_OPEN,           SH1.SH_DISPLAY LEAD_PERSONNEL,           SH2.SH_DISPLAY SUPPORT_PERSONNEL,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN --STAT3.CODE = 'CLOSED' AND                  TRUNC (STAT3.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE)              THEN                 'Yes'              ELSE                 'No'           END              FINAL_DUE_DATE_MET,           O.CREATED_ON CREATED_DATE,           O.CREATED_ON_FY CREATED_ON_FY,           O.LAST_MODIFIED_ON LAST_MODIFIED_DATE,   I.COMPLAINT_SOURCE      FROM MV_F_INTAKE I           INNER JOIN MV_ACM_OBJ O              ON I.OBJ = O.SID           LEFT JOIN MV_ACM_REFERENCE R2              ON I.INITIAL_ASSESSMENT = R2.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R3              ON I.INITIAL_ALLEGATION = R3.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R4              ON I.DISPOSITION = R4.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R5              ON I.INCIDENT_LOCATION = R5.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SUBJECTS                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN V_OBJ_STATUS_HISTORY STAT2              ON I.OBJ = STAT2.OBJ AND STAT2.CODE LIKE 'OPEN'           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'           LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH1              ON I.OBJ = SH1.OBJ AND SH1.CODE = 'LEAD'           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (SH_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY SH_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SH_DISPLAY                        FROM V_CURR_OBJ_STAKEHOLDERS                       WHERE CODE = 'SUPPORT') SH2              ON I.OBJ = SH2.OBJ
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT